package guoanmaker.personal.business.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import guoanmaker.personal.business.model.PersonalCampaign;


public interface PersonalCampaignRepository extends  JpaRepository<PersonalCampaign, String>, JpaSpecificationExecutor<PersonalCampaign> {
	
	@Query("select p from PersonalCampaign p where p.tel=:tel and p.code=:code")
	List<PersonalCampaign> selectCampaignByTelAndCode(@Param("tel")String tel,@Param("code")String code);
}
